


using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace ModelQLKS.Model {
	
        /// <summary>
        /// Table: NHANVIEN
        /// Primary Key: MSNV
        /// </summary>

        public class NHANVIENTable: DatabaseTable {
            
            public NHANVIENTable(IDataProvider provider):base("NHANVIEN",provider){
                ClassName = "NHANVIEN";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MSNV", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 10
                });

                Columns.Add(new DatabaseColumn("HOTENNV", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("MatKhau", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20
                });

                Columns.Add(new DatabaseColumn("NGAYSINHNV", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("GIOITINHNV", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("DIACHINV", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("DIENTHOAINV", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15
                });

                Columns.Add(new DatabaseColumn("NGAYVAOLAM", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("HINH", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 256
                });
                    
                
                
            }
            
            public IColumn MSNV{
                get{
                    return this.GetColumn("MSNV");
                }
            }
            				
   			public static string MSNVColumn{
			      get{
        			return "MSNV";
      			}
		    }
           
            public IColumn HOTENNV{
                get{
                    return this.GetColumn("HOTENNV");
                }
            }
            				
   			public static string HOTENNVColumn{
			      get{
        			return "HOTENNV";
      			}
		    }
           
            public IColumn MatKhau{
                get{
                    return this.GetColumn("MatKhau");
                }
            }
            				
   			public static string MatKhauColumn{
			      get{
        			return "MatKhau";
      			}
		    }
           
            public IColumn NGAYSINHNV{
                get{
                    return this.GetColumn("NGAYSINHNV");
                }
            }
            				
   			public static string NGAYSINHNVColumn{
			      get{
        			return "NGAYSINHNV";
      			}
		    }
           
            public IColumn GIOITINHNV{
                get{
                    return this.GetColumn("GIOITINHNV");
                }
            }
            				
   			public static string GIOITINHNVColumn{
			      get{
        			return "GIOITINHNV";
      			}
		    }
           
            public IColumn DIACHINV{
                get{
                    return this.GetColumn("DIACHINV");
                }
            }
            				
   			public static string DIACHINVColumn{
			      get{
        			return "DIACHINV";
      			}
		    }
           
            public IColumn DIENTHOAINV{
                get{
                    return this.GetColumn("DIENTHOAINV");
                }
            }
            				
   			public static string DIENTHOAINVColumn{
			      get{
        			return "DIENTHOAINV";
      			}
		    }
           
            public IColumn NGAYVAOLAM{
                get{
                    return this.GetColumn("NGAYVAOLAM");
                }
            }
            				
   			public static string NGAYVAOLAMColumn{
			      get{
        			return "NGAYVAOLAM";
      			}
		    }
           
            public IColumn HINH{
                get{
                    return this.GetColumn("HINH");
                }
            }
            				
   			public static string HINHColumn{
			      get{
        			return "HINH";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: KHACHHANG
        /// Primary Key: MSKH
        /// </summary>

        public class KHACHHANGTable: DatabaseTable {
            
            public KHACHHANGTable(IDataProvider provider):base("KHACHHANG",provider){
                ClassName = "KHACHHANG";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MSKH", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("HOTENKH", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("GIOITINHKH", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("DIACHIKH", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("CMND", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10
                });

                Columns.Add(new DatabaseColumn("DIENTHOAIKH", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15
                });
                    
                
                
            }
            
            public IColumn MSKH{
                get{
                    return this.GetColumn("MSKH");
                }
            }
            				
   			public static string MSKHColumn{
			      get{
        			return "MSKH";
      			}
		    }
           
            public IColumn HOTENKH{
                get{
                    return this.GetColumn("HOTENKH");
                }
            }
            				
   			public static string HOTENKHColumn{
			      get{
        			return "HOTENKH";
      			}
		    }
           
            public IColumn GIOITINHKH{
                get{
                    return this.GetColumn("GIOITINHKH");
                }
            }
            				
   			public static string GIOITINHKHColumn{
			      get{
        			return "GIOITINHKH";
      			}
		    }
           
            public IColumn DIACHIKH{
                get{
                    return this.GetColumn("DIACHIKH");
                }
            }
            				
   			public static string DIACHIKHColumn{
			      get{
        			return "DIACHIKH";
      			}
		    }
           
            public IColumn CMND{
                get{
                    return this.GetColumn("CMND");
                }
            }
            				
   			public static string CMNDColumn{
			      get{
        			return "CMND";
      			}
		    }
           
            public IColumn DIENTHOAIKH{
                get{
                    return this.GetColumn("DIENTHOAIKH");
                }
            }
            				
   			public static string DIENTHOAIKHColumn{
			      get{
        			return "DIENTHOAIKH";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: TRANGBITRANGTB
        /// Primary Key: MSLOAIPHONG
        /// </summary>

        public class TRANGBITRANGTBTable: DatabaseTable {
            
            public TRANGBITRANGTBTable(IDataProvider provider):base("TRANGBITRANGTB",provider){
                ClassName = "TRANGBITRANGTB";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MSLOAIPHONG", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 2
                });

                Columns.Add(new DatabaseColumn("MSTB", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 3
                });

                Columns.Add(new DatabaseColumn("SOLUONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn MSLOAIPHONG{
                get{
                    return this.GetColumn("MSLOAIPHONG");
                }
            }
            				
   			public static string MSLOAIPHONGColumn{
			      get{
        			return "MSLOAIPHONG";
      			}
		    }
           
            public IColumn MSTB{
                get{
                    return this.GetColumn("MSTB");
                }
            }
            				
   			public static string MSTBColumn{
			      get{
        			return "MSTB";
      			}
		    }
           
            public IColumn SOLUONG{
                get{
                    return this.GetColumn("SOLUONG");
                }
            }
            				
   			public static string SOLUONGColumn{
			      get{
        			return "SOLUONG";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: THUEPHONG
        /// Primary Key: SOHDONGTHUEPHONG
        /// </summary>

        public class THUEPHONGTable: DatabaseTable {
            
            public THUEPHONGTable(IDataProvider provider):base("THUEPHONG",provider){
                ClassName = "THUEPHONG";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("SOHDONGTHUEPHONG", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MSNV", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 10
                });

                Columns.Add(new DatabaseColumn("MSPHONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 10
                });

                Columns.Add(new DatabaseColumn("NGAYTHUE", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("NGAYTRADK", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn SOHDONGTHUEPHONG{
                get{
                    return this.GetColumn("SOHDONGTHUEPHONG");
                }
            }
            				
   			public static string SOHDONGTHUEPHONGColumn{
			      get{
        			return "SOHDONGTHUEPHONG";
      			}
		    }
           
            public IColumn MSNV{
                get{
                    return this.GetColumn("MSNV");
                }
            }
            				
   			public static string MSNVColumn{
			      get{
        			return "MSNV";
      			}
		    }
           
            public IColumn MSPHONG{
                get{
                    return this.GetColumn("MSPHONG");
                }
            }
            				
   			public static string MSPHONGColumn{
			      get{
        			return "MSPHONG";
      			}
		    }
           
            public IColumn NGAYTHUE{
                get{
                    return this.GetColumn("NGAYTHUE");
                }
            }
            				
   			public static string NGAYTHUEColumn{
			      get{
        			return "NGAYTHUE";
      			}
		    }
           
            public IColumn NGAYTRADK{
                get{
                    return this.GetColumn("NGAYTRADK");
                }
            }
            				
   			public static string NGAYTRADKColumn{
			      get{
        			return "NGAYTRADK";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: HDTHANHTOANPHONG
        /// Primary Key: SOTHANHTOAN
        /// </summary>

        public class HDTHANHTOANPHONGTable: DatabaseTable {
            
            public HDTHANHTOANPHONGTable(IDataProvider provider):base("HDTHANHTOANPHONG",provider){
                ClassName = "HDTHANHTOANPHONG";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("SOTHANHTOAN", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SOHDONGTHUEPHONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MSNV", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 10
                });

                Columns.Add(new DatabaseColumn("NGAYTHANHTOAN", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("TIENPHONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Currency,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn SOTHANHTOAN{
                get{
                    return this.GetColumn("SOTHANHTOAN");
                }
            }
            				
   			public static string SOTHANHTOANColumn{
			      get{
        			return "SOTHANHTOAN";
      			}
		    }
           
            public IColumn SOHDONGTHUEPHONG{
                get{
                    return this.GetColumn("SOHDONGTHUEPHONG");
                }
            }
            				
   			public static string SOHDONGTHUEPHONGColumn{
			      get{
        			return "SOHDONGTHUEPHONG";
      			}
		    }
           
            public IColumn MSNV{
                get{
                    return this.GetColumn("MSNV");
                }
            }
            				
   			public static string MSNVColumn{
			      get{
        			return "MSNV";
      			}
		    }
           
            public IColumn NGAYTHANHTOAN{
                get{
                    return this.GetColumn("NGAYTHANHTOAN");
                }
            }
            				
   			public static string NGAYTHANHTOANColumn{
			      get{
        			return "NGAYTHANHTOAN";
      			}
		    }
           
            public IColumn TIENPHONG{
                get{
                    return this.GetColumn("TIENPHONG");
                }
            }
            				
   			public static string TIENPHONGColumn{
			      get{
        			return "TIENPHONG";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: LOAIPHONG
        /// Primary Key: MSLOAIPHONG
        /// </summary>

        public class LOAIPHONGTable: DatabaseTable {
            
            public LOAIPHONGTable(IDataProvider provider):base("LOAIPHONG",provider){
                ClassName = "LOAIPHONG";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MSLOAIPHONG", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 2
                });

                Columns.Add(new DatabaseColumn("TENLOAIPHONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("GIATIEN", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Currency,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn MSLOAIPHONG{
                get{
                    return this.GetColumn("MSLOAIPHONG");
                }
            }
            				
   			public static string MSLOAIPHONGColumn{
			      get{
        			return "MSLOAIPHONG";
      			}
		    }
           
            public IColumn TENLOAIPHONG{
                get{
                    return this.GetColumn("TENLOAIPHONG");
                }
            }
            				
   			public static string TENLOAIPHONGColumn{
			      get{
        			return "TENLOAIPHONG";
      			}
		    }
           
            public IColumn GIATIEN{
                get{
                    return this.GetColumn("GIATIEN");
                }
            }
            				
   			public static string GIATIENColumn{
			      get{
        			return "GIATIEN";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: CHITIETTHUEPHONG
        /// Primary Key: MSKH
        /// </summary>

        public class CHITIETTHUEPHONGTable: DatabaseTable {
            
            public CHITIETTHUEPHONGTable(IDataProvider provider):base("CHITIETTHUEPHONG",provider){
                ClassName = "CHITIETTHUEPHONG";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("SOHDONGTHUEPHONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MSKH", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("VAITRO", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1
                });
                    
                
                
            }
            
            public IColumn SOHDONGTHUEPHONG{
                get{
                    return this.GetColumn("SOHDONGTHUEPHONG");
                }
            }
            				
   			public static string SOHDONGTHUEPHONGColumn{
			      get{
        			return "SOHDONGTHUEPHONG";
      			}
		    }
           
            public IColumn MSKH{
                get{
                    return this.GetColumn("MSKH");
                }
            }
            				
   			public static string MSKHColumn{
			      get{
        			return "MSKH";
      			}
		    }
           
            public IColumn VAITRO{
                get{
                    return this.GetColumn("VAITRO");
                }
            }
            				
   			public static string VAITROColumn{
			      get{
        			return "VAITRO";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: DMPHONG
        /// Primary Key: MSPHONG
        /// </summary>

        public class DMPHONGTable: DatabaseTable {
            
            public DMPHONGTable(IDataProvider provider):base("DMPHONG",provider){
                ClassName = "DMPHONG";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MSPHONG", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 10
                });

                Columns.Add(new DatabaseColumn("MSLOAIPHONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 2
                });

                Columns.Add(new DatabaseColumn("TINHTRANG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1
                });
                    
                
                
            }
            
            public IColumn MSPHONG{
                get{
                    return this.GetColumn("MSPHONG");
                }
            }
            				
   			public static string MSPHONGColumn{
			      get{
        			return "MSPHONG";
      			}
		    }
           
            public IColumn MSLOAIPHONG{
                get{
                    return this.GetColumn("MSLOAIPHONG");
                }
            }
            				
   			public static string MSLOAIPHONGColumn{
			      get{
        			return "MSLOAIPHONG";
      			}
		    }
           
            public IColumn TINHTRANG{
                get{
                    return this.GetColumn("TINHTRANG");
                }
            }
            				
   			public static string TINHTRANGColumn{
			      get{
        			return "TINHTRANG";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: SUDUNGDV
        /// Primary Key: MSTB
        /// </summary>

        public class SUDUNGDVTable: DatabaseTable {
            
            public SUDUNGDVTable(IDataProvider provider):base("SUDUNGDV",provider){
                ClassName = "SUDUNGDV";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("SOHDONGTHUEPHONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MSTB", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 3
                });

                Columns.Add(new DatabaseColumn("NGAYSD", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SOLUONG", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn SOHDONGTHUEPHONG{
                get{
                    return this.GetColumn("SOHDONGTHUEPHONG");
                }
            }
            				
   			public static string SOHDONGTHUEPHONGColumn{
			      get{
        			return "SOHDONGTHUEPHONG";
      			}
		    }
           
            public IColumn MSTB{
                get{
                    return this.GetColumn("MSTB");
                }
            }
            				
   			public static string MSTBColumn{
			      get{
        			return "MSTB";
      			}
		    }
           
            public IColumn NGAYSD{
                get{
                    return this.GetColumn("NGAYSD");
                }
            }
            				
   			public static string NGAYSDColumn{
			      get{
        			return "NGAYSD";
      			}
		    }
           
            public IColumn SOLUONG{
                get{
                    return this.GetColumn("SOLUONG");
                }
            }
            				
   			public static string SOLUONGColumn{
			      get{
        			return "SOLUONG";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: dtproperties
        /// Primary Key: id
        /// </summary>

        public class dtpropertiesTable: DatabaseTable {
            
            public dtpropertiesTable(IDataProvider provider):base("dtproperties",provider){
                ClassName = "dtproperty";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("objectid", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("property", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 64
                });

                Columns.Add(new DatabaseColumn("value", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("uvalue", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("lvalue", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Binary,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });

                Columns.Add(new DatabaseColumn("version", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn id{
                get{
                    return this.GetColumn("id");
                }
            }
            				
   			public static string idColumn{
			      get{
        			return "id";
      			}
		    }
           
            public IColumn objectid{
                get{
                    return this.GetColumn("objectid");
                }
            }
            				
   			public static string objectidColumn{
			      get{
        			return "objectid";
      			}
		    }
           
            public IColumn property{
                get{
                    return this.GetColumn("property");
                }
            }
            				
   			public static string propertyColumn{
			      get{
        			return "property";
      			}
		    }
           
            public IColumn value{
                get{
                    return this.GetColumn("value");
                }
            }
            				
   			public static string valueColumn{
			      get{
        			return "value";
      			}
		    }
           
            public IColumn uvalue{
                get{
                    return this.GetColumn("uvalue");
                }
            }
            				
   			public static string uvalueColumn{
			      get{
        			return "uvalue";
      			}
		    }
           
            public IColumn lvalue{
                get{
                    return this.GetColumn("lvalue");
                }
            }
            				
   			public static string lvalueColumn{
			      get{
        			return "lvalue";
      			}
		    }
           
            public IColumn version{
                get{
                    return this.GetColumn("version");
                }
            }
            				
   			public static string versionColumn{
			      get{
        			return "version";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: THIETBI_DV
        /// Primary Key: MSTB
        /// </summary>

        public class THIETBI_DVTable: DatabaseTable {
            
            public THIETBI_DVTable(IDataProvider provider):base("THIETBI_DV",provider){
                ClassName = "THIETBI_DV";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MSTB", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 3
                });

                Columns.Add(new DatabaseColumn("TENTHIETBI", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("DVT", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10
                });

                Columns.Add(new DatabaseColumn("GIATB", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Currency,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("THIETBICODINH", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1
                });
                    
                
                
            }
            
            public IColumn MSTB{
                get{
                    return this.GetColumn("MSTB");
                }
            }
            				
   			public static string MSTBColumn{
			      get{
        			return "MSTB";
      			}
		    }
           
            public IColumn TENTHIETBI{
                get{
                    return this.GetColumn("TENTHIETBI");
                }
            }
            				
   			public static string TENTHIETBIColumn{
			      get{
        			return "TENTHIETBI";
      			}
		    }
           
            public IColumn DVT{
                get{
                    return this.GetColumn("DVT");
                }
            }
            				
   			public static string DVTColumn{
			      get{
        			return "DVT";
      			}
		    }
           
            public IColumn GIATB{
                get{
                    return this.GetColumn("GIATB");
                }
            }
            				
   			public static string GIATBColumn{
			      get{
        			return "GIATB";
      			}
		    }
           
            public IColumn THIETBICODINH{
                get{
                    return this.GetColumn("THIETBICODINH");
                }
            }
            				
   			public static string THIETBICODINHColumn{
			      get{
        			return "THIETBICODINH";
      			}
		    }
           
                    
        }
        
}